Teradata SQL: DDL, DML, and SQL Optimization

Teradata SQL: DDL, DML, and SQL Optimization

• start the course
• create and alter a database in Teradata
• create and manage database users for Teradata
• create a table in Teradata using the CREATE TABLE statement
• create a table in Teradata using the CREATE TABLE statement which includes defining an index, column definitions, and table options
• alter, manage, and drop tables in Teradata
• create and alter indexes in Teradata
• create and alter views in Teradata
• create recursive views in Teradata
• create macros in Teradata
• create triggers in Teradata
• create procedures in Teradata
• alter, rename, and drop functions and stored procedures in Teradata
• use the QUALIFY clause in Teradata
• use NORMALIZED in a SELECT statement in Teradata
• use the EXPAND ON clause in a SELECT statement in Teradata
• use the INSERT statement to insert data into Teradata
• use the UPDATE statement to update data in Teradata
• use the DELETE statement to remove data from Teradata
• use MERGE to merge data into a table in Teradata
• identify how to optimize query design in Teradata
• identify how to improve the performance of merge joins in Teradata
• describe the basic temporal concepts in Teradata
• create temporal tables in Teradata
• load data into temporal tables in Teradata
• perform DDL operations using their temporal form in Teradata
• perform DML operations using their temporal form in Teradata
• perform DDL and DML operations on regular and temporal tables in Teradata

Teradata SQL: Functions, Data Conversions, and Working with Time

Teradata SQL: Functions, Data Conversions, and Working with Time

• start the course
• identify the different types of functions in Teradata and how expressions and SQL operators are used
• use arithmetic functions and operators on data in Teradata
• use attribute functions to return descriptive information about their operand in Teradata
• use string functions to perform operations on strings of data in Teradata
• use regular expression functions on data in Teradata
• use the analytical functions in Teradata
• use CASE expressions to evaluate a set of expressions in Teradata
• use calendar functions to work with dates, months, and years in Teradata
• use ANSI DateTime expressions to do computations with Time Zones and interval values in Teradata
• use ANSI Interval expressions to perform calculations on Interval values in Teradata
• use arithmetic operators, ANSI DateTime, and Interval Data Types in Teradata
• use scalar operations with DateTime functions to work with dates and times in Teradata
• use the different DateTime and Interval functions, ADD_MONTHS, OADD_MONTHS, AND MONTHS_BETWEEN in Teradata
• use the different DateTime and Interval functions, LAST_DAY, NEXT_DAY, TRUNC, ROUND, EXTRACT in Teradata
• identify the three ways data types are converted in Teradata
• identify when implicit data conversion is performed and what the supported data types are
• identify the syntax and rules for using CAST to perform data conversions in Teradata
• use data type conversion functions to convert characters in Teradata with CAST
• use data type conversion to convert numbers, times, and intervals in Teradata with CAST
• identify and use the data type conversion functions to convert data in Teradata
• describe the set operators, their syntax, and order precedence for use in Teradata
• use the INTERSECT set operator in Teradata
• use the MINUS and EXCEPT set operators in Teradata
• use the UNION set operator in Teradata
• use set operators in derived tables, subqueries, and SELECT...INSERT statements in Teradata
• use functions, expressions, and operations in Teradata to work with data

Teradata SQL: The SELECT Statement, Joins, and Subqueries

Teradata SQL: The SELECT Statement, Joins, and Subqueries

• start the course
• describe SQL and how it can be used in Teradata
• launch and use the BTEQ command line tool and identify how it is used as a query management tool
• describe the different clauses in a SELECT statement
• perform basic SELECT statements in Teradata
• use basic WHERE clause in a SELECT statement to perform conditional queries in Teradata
• perform advanced WHERE clause searches in a SELECT statement to limit results in Teradata
• use the ORDER BY clause in a SELECT statement to perform a query in Teradata
• use the GROUP BY and HAVING clauses to perform grouping in query results in Teradata
• use TOP, SAMPLE, and the SAMPLEID expression in a SELECT statement to limit results in Teradata
• use MIN, MAX, COUNT, AVG, SUM aggregates in a SELECT statement in Teradata
• use GROUPING SETS, ROLLUP, and CUBE to analyze data across a dimension in Teradata
• use the WITH clause in a SELECT statement in Teradata
• describe the different types of joins that can be performed in Teradata
• perform natural joins in Teradata
• perform theta joins in Teradata
• perform inner joins in Teradata
• perform outer joins in Teradata
• perform self joins and cross joins in Teradata
• perform multitable joins in Teradata
• describe subqueries, scalar subqueries, and correlated subqueries, and how they are used in Teradata to retrieve results
• perform basic subqueries in a SELECT statement to return results from Teradata
• perform subqueries in the search condition of a WHERE clause
• perform scalar subqueries to return results from Teradata
• perform correlated subqueries to return results from Teradata
• create and use derived tables in Teradata
• use the SELECT statement to perform queries, including performing joins and subqueries